-- ----------------------------
-- Records of holi_date
-- ----------------------------
BEGIN;
INSERT INTO `holi_date`(`date_time`, `weekday`, `year`, `month`, `day`, `holiday`, `holiday_name`, `holiday_type`)
VALUES
    ('2025-01-01', 3, 2025, 1, 1, 1, '元旦节', 2),
    ('2025-01-26', 0, 2025, 1, 26, 0, '春节补班', 3),
    ('2025-01-28', 2, 2025, 1, 28, 1, '春节第一天', 2),
    ('2025-01-29', 3, 2025, 1, 29, 1, '春节第二天', 2),
    ('2025-01-30', 4, 2025, 1, 30, 1, '春节第三天', 2),
    ('2025-01-31', 5, 2025, 1, 31, 1, '春节第四天', 2),
    ('2025-02-01', 6, 2025, 2, 1, 1, '春节第五天', 2),
    ('2025-02-02', 0, 2025, 2, 2, 1, '春节第六天', 2),
    ('2025-02-03', 1, 2025, 2, 3, 1, '春节第七天', 2),
    ('2025-02-04', 2, 2025, 2, 4, 1, '春节第八天', 2),
    ('2025-02-08', 6, 2025, 2, 8, 0, '春节补班', 3),
    ('2025-04-04', 5, 2025, 4, 4, 1, '清明节第一天', 2),
    ('2025-04-05', 6, 2025, 4, 5, 1, '清明节第二天', 2),
    ('2025-04-06', 0, 2025, 4, 6, 1, '清明节第三天', 2),
    ('2025-04-27', 0, 2025, 4, 27, 0, '劳动节补班', 3),
    ('2025-05-01', 4, 2025, 5, 1, 1, '劳动节第一天', 2),
    ('2025-05-02', 5, 2025, 5, 2, 1, '劳动节第二天', 2),
    ('2025-05-03', 6, 2025, 5, 3, 1, '劳动节第三天', 2),
    ('2025-05-04', 0, 2025, 5, 4, 1, '劳动节第四天', 2),
    ('2025-05-05', 1, 2025, 5, 5, 1, '劳动节第五天', 2),
    ('2025-05-31', 6, 2025, 5, 31, 1, '端午节第一天', 2),
    ('2025-06-01', 0, 2025, 6, 1, 1, '端午节第二天', 2),
    ('2025-06-02', 1, 2025, 6, 2, 1, '端午节第三天', 2),
    ('2025-09-28', 0, 2025, 9, 28, 0, '国庆节补班', 3),
    ('2025-10-01', 3, 2025, 10, 1, 1, '国庆节第一天', 2),
    ('2025-10-02', 4, 2025, 10, 2, 1, '国庆节第二天', 2),
    ('2025-10-03', 5, 2025, 10, 3, 1, '国庆节第三天', 2),
    ('2025-10-04', 6, 2025, 10, 4, 1, '国庆节第四天', 2),
    ('2025-10-05', 0, 2025, 10, 5, 1, '国庆节第五天', 2),
    ('2025-10-06', 1, 2025, 10, 6, 1, '国庆节第六天', 2),
    ('2025-10-07', 2, 2025, 10, 7, 1, '国庆节第七天', 2),
    ('2025-10-08', 3, 2025, 10, 8, 1, '国庆节第八天', 2),
    ('2025-10-11', 6, 2025, 10, 11, 0, '国庆节补班', 3);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;